IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CovenatGet')
	BEGIN
		DROP  Procedure  CovenatGet
	END

GO

CREATE Procedure CovenatGet
	@CovenantID int
AS
SELECT 
CovenantID,
TemplateStyle,
Name,
TagLine,
Header,
CurrentAffairs,
SagaSummary,
FormationStory,
CurrentYear,
DATENAME(month, CONVERT(DATETIME, CONVERT(nvarchar,FoundedMonth) + '/1/2000') ) + ' ' + CONVERT(nvarchar, FoundedYear) + ' A.D.' as FoundedDate
FROM Covenant 

WHERE CovenantID = @CovenantID
